home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / DROPCAT5.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  3.1 KB  |  107 lines
  1. rem 
  2. rem $Header: dropcat5.sql 7020100.1 94/09/23 22:14:43 cli Generic<base> $ dropcat5.sql 
  3. rem 
  4. Rem Copyright (c) 1988 by Oracle Corporation
  5. Rem NAME
  6. Rem    dropcat5.sql
  7. Rem  FUNCTION
  8. Rem    Drop version 5 dictionary objects owned by SYSTEM
  9. Rem  NOTES
  10. Rem    This script should be run while logged-in as SYSTEM on a version 5
  11. Rem    database.  It drops all version 5 dictionary objects.
  12. Rem    If a user is about to perform a full database export of a
  13. Rem    version 5 database that will be imported into a version 6
  14. Rem    database, he should first run this script to prevent the export
  15. Rem    and later import of the old dictionary objects. 
  16. Rem    All version 6 dictionary objects are owned by SYS, while version 5
  17. Rem    dictionary objects are owned by SYSTEM. 
  18. Rem
  19. Rem  MODIFIED
  20. Rem   Mendels    07/26/88 - Creation
  21. Rem
  22. set echo on
  23. drop public synonym dual;
  24. drop public synonym taballoc;
  25. drop public synonym storage;
  26. drop public synonym extents;
  27. drop public synonym spaces;
  28. drop public synonym syscolumns;
  29. drop public synonym columns;
  30. drop public synonym syscatalog;
  31. drop public synonym catalog;
  32. drop public synonym sysindexes;
  33. drop public synonym indexes;
  34. drop public synonym views;
  35. drop public synonym sysviews;
  36. drop public synonym systabauth;
  37. drop public synonym syscolauth;
  38. drop public synonym sysuserlist;
  39. drop public synonym sysprogs;
  40. drop public synonym synonyms;
  41. drop public synonym publicsyn;
  42. drop public synonym privatesyn;
  43. drop public synonym tab;
  44. drop public synonym col;
  45. drop public synonym tabquotas;
  46. drop public synonym dtab;
  47. drop public synonym partitions;
  48. drop public synonym systaballoc;
  49. drop public synonym sysstorage;
  50. drop public synonym sysextents;
  51. drop public synonym sysuserauth;
  52. drop public synonym system_audit;
  53. drop public synonym default_audit;
  54. drop public synonym table_audit;
  55. drop public synonym audit_actions;
  56. drop public synonym audit_trail;
  57. drop public synonym sysaudit_trail;
  58. drop public synonym audit_dba;
  59. drop public synonym audit_exists;
  60. drop public synonym audit_connect;
  61. drop public synonym sessions;
  62. drop public synonym audit_access;
  63. drop public synonym clusters;
  64. drop public synonym clustercolumns;
  65. drop table dual;
  66. drop view taballoc;
  67. drop view storage;
  68. drop view extents;
  69. drop view spaces;
  70. drop view syscolumns;
  71. drop view columns;
  72. drop view syscatalog;
  73. drop view catalog;
  74. drop view sysindexes;
  75. drop view indexes;
  76. drop view views;
  77. drop view sysviews;
  78. drop view systabauth;
  79. drop view syscolauth;
  80. drop view sysuserlist;
  81. drop view sysprogs;
  82. drop view synonyms;
  83. drop view publicsyn;
  84. drop view privatesyn;
  85. drop view tab;
  86. drop view col;
  87. drop view tabquotas;
  88. drop table dtab;
  89. drop view partitions;
  90. drop view systaballoc;
  91. drop view sysstorage;
  92. drop view sysextents;
  93. drop view sysuserauth;
  94. drop view system_audit;
  95. drop view default_audit;
  96. drop view table_audit;
  97. drop table audit_actions;
  98. drop view audit_trail;
  99. drop view audit_dba;
  100. drop view audit_exists;
  101. drop view audit_connect;
  102. drop view sessions;
  103. drop view audit_access;
  104. drop view clusters;
  105. drop view clustercolumns;
  106. set echo off;
  107.